92

Beginner’s Guide to Code Algorithms

92

FIGURE 6.1  Merge utility.

Row 2 is where you would provide the name of the target file.

Row 3 is the source folder where you will store all the workbooks you received

from the stores. Note that you should take care not to have any other file or else this

would get picked up as well.

Row 4 is the uniform staring position for each source worksheet.

Row 5 is the start column of the data.

Row 6 is to indicate the deletion of traces created by the program. The program

is written in such a way that the name of the source file is copied over in a far-​away

column just to ensure you can check which workbook the data came from.

Row 7 is a mandatory column where you will always expect data in the source sheets.

If this column is blank for any row, then there are no data in that row. This is a rule we

make up to ensure that we can systematically ensure all rows have been copied.

Rows 8 and 9 have a button that triggers the macro.

The button is just a shape that can be inserted using the following menu path.

FIGURE 6.2  Shapes.